Main
Andrés Felipe Insuasty Ch.
I have implemented 2 internal packages in my previous works. Currently I have been part of developing packages and shiny apps for health industry in Colombia. On my blog, I give some tips recorded from my work
Experience
R / Shiny developer
MD&CO Consulting
Remote
Current - 12/07/2021
- Help on the develpment of shiny solutions to health sector in Colombia. Projects:
- https://github.com/proyais/aisalud_agrupador
- https://github.com/proyais/aisalud_rutas
- https://github.com/proyais/aisalud
- shiny, shinyWidgets, gargoyle, vim, css, html, git, purrr, JSON, dplyr
Campaigns coordinator - Data Analytics
Banco Agrario de Colombia
Bogotá, Colombia
10/07/2021 - 01/08/2020
- Creator of an internal R package to manage sales campaigns in the bank.
- Automation of daily, weekly and monthly campaigns: Operational time reduced: 80 hours monthly
- Client assignment to salesforce using R package for mathematical modelling: Precission of assigment on 100% , operation time reduced: 4 hours monthly.
- Use of git to manage control version in the package among the team.
- readr, readxl, dplyr, DBI, Rmarkdown, blastula, tidyverse, tidytext, ompr, sql, shiny
Business Analyst
Ajover S.A.S
Bogotá, Colombia
20/03/2020 - 03/13/2017
- Implementation of a Master Planning optimization model.
- I Developed 12 automatic reports using R
- Tunning ETL process trought SQL.
- openxlsx, DBI, tidyverse, lubridate, stringr, ggplot2, Rmarkdown, mailR, sql, shiny
Process Analyst
Carvajal Tecnologia y Servicios
Cali, Colombia
03/10/2017 - 11/11/2015
- Led 3 Analytics projects using QlickView as a BI tool: Vendor Analytics, Daily Cash Flow and Cash flow forecasting
- openxlsx, tidyverse, ggplot2, plotly
Project Engineer
DecisionWare
Madrid, Spain
01/08/2015 - 01/07/2014
- Support (Technical and commercial) on projects focused on improving and optimizing business processes using Operations Research, Mathematical Modelling.
- Excel, PowerPoint
Education
MSc. Statistics and Operations Research
Universitat Politècnica de Catalunya
Barcelona, Spain
12/07/2015 - 12/07/2013
- Focused on Operations Reasearch
- R, SQL, AMPL,lm
B.S., Industrial Enginner
Universidad Icesi
Cali, Colombia
12/07/2012 - 12/07/2007
- Excel, PowerPoint, AMPL, lm